package cn.wolfcode.shop.cloud.mapper;

import cn.wolfcode.shop.cloud.domain.Good;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.SelectProvider;

import java.util.ArrayList;
import java.util.List;

@Mapper
public interface GoodMapper {

    /**
     * 第一个参数 class
     * 第二个是方法
     *
     *
     */
    @SelectProvider(type = SelectQuery.class,method = "queryByIds")
    List<Good> queryByIds(@Param("ids")ArrayList<Long> ids);

    class SelectQuery{
        public String queryByIds(@Param("ids") List<Long> ids){
            StringBuilder sb = new StringBuilder(100);
            sb.append(" select * from t_goods where id in ( ");
            for (int i = 0; i < ids.size(); i++) {
                if (i!=0){
                    sb.append(",");
                }
                sb.append(ids.get(i));
            }
            sb.append(" ) ");
            return sb.toString();
        }
    }
}
